CREATE TABLE [dbo].[Content_Pages]
(
[PAGE_NUM] [int] NOT NULL CONSTRAINT [DF_Content_Pages_PAGE_NUM] DEFAULT ((0)),
[PAGE_TITLE] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Content_Pages_PAGE_TITLE] DEFAULT (''),
[PAGE_DESCR] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATION_DATE] [datetime] NULL,
[EXPIRATION_DATE] [datetime] NULL,
[BUILD_DATE] [datetime] NULL,
[PAGE_TYPE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Content_Pages_PAGE_TYPE] DEFAULT (''),
[SECURITY_GROUP] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Content_Pages_SECURITY_GROUP] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Content_Pages] ADD CONSTRAINT [PK_Content_Pages] PRIMARY KEY NONCLUSTERED ([PAGE_NUM]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iContent_PagesPAGE_TYPE] ON [dbo].[Content_Pages] ([PAGE_TYPE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Content_Pages] TO [IMIS]
GRANT SELECT ON  [dbo].[Content_Pages] TO [IMIS]
GRANT INSERT ON  [dbo].[Content_Pages] TO [IMIS]
GRANT DELETE ON  [dbo].[Content_Pages] TO [IMIS]
GRANT UPDATE ON  [dbo].[Content_Pages] TO [IMIS]
GO